
package com.be.beadmin.design.repository;

import com.be.beadmin.design.entity.StandProductProcessInfo;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;

import java.util.List;

/**
* @author ljh
* @date 2023-06-13
**/
public interface StandProductProcessInfoRepository extends JpaRepository<StandProductProcessInfo, String>, JpaSpecificationExecutor<StandProductProcessInfo> {

    StandProductProcessInfo findStandProductProcessInfoByIdAndDelete(String id, Integer delete);

    StandProductProcessInfo findStandProductProcessInfoByStandTypeIdAndProcessIdAndDelete(String standTypeId,String processId, Integer delete);
    StandProductProcessInfo findStandProductProcessInfoByStandTypeCodeAndProcessCode(String standTypeCode, String processCode);

    StandProductProcessInfo findStandProductProcessInfoById(String id);

    List<StandProductProcessInfo> findStandProductProcessInfoByStandTypeIdAndDelete(String standTypeId,Integer delete);

    List<StandProductProcessInfo> findStandProductProcessInfoByStandTypeIdAndIsProductionProcessAndDelete(String standTypeId, Integer isProductionProcess,  Integer delete);

    List<StandProductProcessInfo> findStandProductProcessInfoByProcessIdAndDelete(String id, int delete);

    List<StandProductProcessInfo> findStandProductProcessInfoByStandTypeIdInAndDelete(List<String> standTypeIds, Integer delete);
}